Select [Org].[DBId] as [ResDBId], [Org].[GLAccountId] as [ResGLAccountId], [Org].[CurrencyId] as [ResCurrencyId], [Org].[Type] as [ResType], [Dest].[CyStartBalance] as [ResCyStartBalance], [Org].[CyEndBalance] as [ResCyEndBalance], [Org].[Value] as [ResOptionValue] from(Select [GLYEBalance].[DBId], [GLYEBalance].[GLAccountId], [GLYEBalance].[CurrencyId], [GLYEBalance].[Type], [GLYEBalance].[StartDate], [GLYEBalance].[EndDate], [GLYEBalance].[CyStartBalance], [GLYEBalance].[CyEndBalance], [Options].[Value]from (([GLYEBalance] INNER JOIN [GLPeriod]ON ([GLYEBalance].[GLPeriodId] = [GLPeriod].[Id] and [GLYEBalance].[DBId] = [GLPeriod].[DBId]))LEFT JOIN [Options]ON ([Options].[DBId] = [GLYEBalance].[DBId] and [Options].[Variable] = ‘RetainedEarnings_GLAccountId’ and [Options].[Value] = … Continue reading Query: Select invalid GLYEBalance